Tabela HierarchyType

Definicja tabeli HierarchyType

Name

HierarchyType

Code

HierarchyType

Comment

 


Lista kolumn tabeli HierarchyType

Name

Code

HierarchyTypeID

HierarchyTypeID

Active

Active

InterfaceCd

InterfaceCd

Code

Code

Description

Description

FullName

FullName

ShortName

ShortName


Kolumna HierarchyTypeID tabeli HierarchyType

Definicja kolumny HierarchyTypeID tabeli HierarchyType

Name

HierarchyTypeID

Code

HierarchyTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli HierarchyType

Definicja kolumny Active tabeli HierarchyType

Name

Active

Code

Active

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna InterfaceCd tabeli HierarchyType

Definicja kolumny InterfaceCd tabeli HierarchyType

Name

InterfaceCd

Code

InterfaceCd

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Code tabeli HierarchyType

Definicja kolumny Code tabeli HierarchyType

Name

Code

Code

Code

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Description tabeli HierarchyType

Definicja kolumny Description tabeli HierarchyType

Name

Description

Code

Description

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna FullName tabeli HierarchyType

Definicja kolumny FullName tabeli HierarchyType

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ShortName tabeli HierarchyType

Definicja kolumny ShortName tabeli HierarchyType

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Lista kluczy tabeli HierarchyType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli HierarchyType

Definicja klucza Identifier_1 tabeli HierarchyType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment